# coding=utf-8
# Copyright 2018 The Google AI Language Team Authors.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
"""Adds indices to databases which require them."""
from __future__ import absolute_import
from __future__ import division
from __future__ import print_function

import argparse
import sqlite3


def main(db_name):
  with open('data_utils/extra_' + db_name + '_indices.txt') as infile:
    indices = infile.read().split('\n')

  db = sqlite3.connect('databases/' + db_name + '.db')
  c = db.cursor()

  for index in indices:
    print('Adding index:')
    print(index)
    q = index
    c.execute(q)
    db.commit()

  db.close()


if __name__ == '__main__':
  parser = argparse.ArgumentParser()
  parser.add_argument(
      '--database_name', type=str, help='The database to add indices to.')
  args = parser.parse_args()
  main(args.database_name)
